The insert statement cannot have a select statement in the values clause as one of the values to be inserted Insert语句不能在values子句中将select语句用作插入值之一。
In an insert statement , a select statement returning a scalar value is allowed in the values clause 在insert语句中,允许在values子句中使用可以返回标量值的select语句。
Typically , the original value is used as a parameter in a where clause to identify the record in the database , and the current value is used in set or values clauses 通常情况下,原始值用作where子句中的参数以标识数据库中的记录,而当前值则用于set或values子句中。
For example , when the update process gets to a new record in the dataset table a record for which it must call an insert statement in the database the values for the insert statement s value clause can be read directly out of the record 例如,当更新进程到达数据集表中的一个新记录(必须为其在数据库中调用insert语句)时, insert语句的value子句的值可以从该记录直接读出。